Combining Relational and Semi-structured Databases for an Inquiry Application
نویسندگان
چکیده
The popularity of NoSQL databases keeps growing and more companies have been moving away from relational databases to nonrelational NoSQL databases. In this paper, the partitioning of a relational data model of an inquiry system into semi-structured and relational data for storage in both SQL and NoSQL databases is shown. Furthermore, the CAP theorem will be applied to categorize the storing of the correct parts of the model into their corresponding databases. As a result of these reorganizations and the introduction of additional histogram data, overall performance improvements of about 93% to 98% are achieved.
منابع مشابه
An Analysis of Relational Storage Strategies for Partially Structured XML
This paper presents a performance analysis of strategies for storing XML data sets in relational databases, focusing on XML datasets that are a combination of structured and semi-structured data. The analysis demonstrates advantages of a hybrid approach combining structure mapping and XML data type instances. However problems remain with current technology with regards to scaling of the approac...
متن کاملA Semi-Structured Data Cartridge for Relational Databases
In this paper, we present our experiences on managing semi-structured data in relational databases. We use a Java package built on top of relational database for store and query semi-structured data. In this work, we introduced a more complete data model, a flexible storage scheme, and a compact metedata structure for processing regular path expressions.
متن کاملHRDBMS: Combining the Best of Modern and Traditional Relational Databases
HRDBMS is a novel distributed relational database that uses a hybrid model combining the best of traditional distributed relational databases and Big Data analytics platforms such as Hive. This allows HRDBMS to leverage years worth of research regarding query optimization, while also taking advantage of the scalability of Big Data platforms. The system uses an execution framework that is tailor...
متن کاملThe Integrated WG - Log System for Querying Semi - structuredInformationSara
Metodologie e tecnologie per la gestione di dati e processi su reti Internet e Intranet Sommario Nowadays several information systems comprise a number of heterogeneous datasources, such as relational, object-oriented or object-relational databases. Moreover, an increasing amount of information is being made available through unstructured and semi-structured datasources such as collections of t...
متن کاملAlgebraic Languages for Xml Databases
XML is becoming increasingly popular as a means of exchanging a wide variety of data on the web. It is anticipated that in the future, many websites will be built from XML documents. XML databases would be required to manage these websites and also provide a way for users to search their contents. In this paper we give an overview of the development of query algebras from the original relationa...
متن کامل